- 2 minutes to read
SqlPackageParams - System Parameter
Microsoft breaks compatibiliy with the 161 version of DacFX. To overcome this change you must run a matching set of binaries:
| DaxFX Version | Nodinite Install and Update Tool | Nodinite |
|---|---|---|
| >= 161 | >=6.0.0.5 | >= 5.4.1.26 |
| < 161 | < 6.0.0.5 | < 5.4.1.26 |
The System parameter SqlPackageParams is used to instruct the Nodinite Logging Service how to connect with SQL Server. Also, the Nodinite Install and Update Tool makes use of this value when you are updating the system.
| System Parameter Name | Data Type | Values/Example | Comment |
|---|---|---|---|
| SqlPackageParams | json | json object as exemplified | Default = {"TargetTrustServerCertificate":true,"TargetEncryptConnection":true,"SourceTrustServerCertificate":false,"SourceEncryptConnection":true} |
This feature was introduced with version 5.4.1.26
JSON Structure and example
- TargetTrustServerCertificate - default true,
- TargetEncryptConnection - default true,
- SourceTrustServerCertificate - default false
- SourceEncryptConnection - default true
{"TargetTrustServerCertificate":true,"TargetEncryptConnection":true,"SourceTrustServerCertificate":false,"SourceEncryptConnection":true}
Frequently asked questions
Additional solutions to common problems and the FAQ for the Nodinite System Parameters exist in the Troubleshooting user guide.
Where can I get the latest DacFX?
Please download and install the latest DacFX.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.